StudentAccountPendingTransactionCourse 
EntityType  Independent 
Logical Entity Name  StudentAccountPendingTransactionCourse 
Default Table Name  SaPendingChargeCourseAmount 
Logical Only  NO 
Definition 
 
Note 
 

StudentAccountPendingTransactionCourse Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentAccountPendingTransactionCourseId(PK)    INTEGER  NO 
 
StudentEnrollmentPeriodId(FK)    INTEGER  NO 
 
SaAutoBillBatchDetailID(FK)    INTEGER  YES 
 
StudentAccountPendingTransactionId(FK)    INTEGER  YES 
 
TermId(FK)    INTEGER  NO 
 
CourseId(FK)    INTEGER  NO 
 
BillingTransactionCodeId(FK)    INTEGER  NO 
 
CampusId(FK)    INTEGER  NO 
 
Amount    MONEY(19, 4)  NO 
 
LastModifiedUserId(FK)    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
ClassSectionId(FK)    INTEGER  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 

StudentAccountPendingTransactionCourse Keys 
Key Name  Key Type  Keys 
SaPendingChargeCourseAmount_UserID_N_N_IDX  Inversion Entry  LastModifiedUserId 
SaPendingChargeCourseAmount_SaPendingChargeID_N_N_IDX  Inversion Entry  StudentAccountPendingTransactionId 
SaPendingChargeCourseAmount_SaBillCodeID_N_N_IDX  Inversion Entry  BillingTransactionCodeId 
SaPendingChargeCourseAmount_SaAutoBillBatchDetailID_N_N_IDX  Inversion Entry  SaAutoBillBatchDetailID 
SaPendingChargeCourseAmount_AdCourseID_N_N_IDX  Inversion Entry  CourseId 
PK_SaPendingChargeCourseAmount_SaPendingChargeCourseAmountID  PrimaryKey  StudentAccountPendingTransactionCourseId 
SaPendingChargeCourseAmount_SyCampusID_AdTermID_AdEnrollID_SaPendingChargeCourseAmountID_U_N_IDX  Alternate Key  CampusId, TermId, StudentEnrollmentPeriodId 

StudentAccountPendingTransactionCourse Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
BillingTransactionCode  Non-Identifying  Zero or One to Zero or More        BillingTransactionCodeId  NO 
Campus  Non-Identifying  Zero or One to Zero or More        CampusId  NO 
ClassSection  Non-Identifying  Zero or One to Zero or More        ClassSectionId  NO 
Course  Non-Identifying  Zero or One to Zero or More        CourseId  NO 
ClassSection  Non-Identifying  Zero or One to Zero or More        ClassSectionId  NO 
Course  Non-Identifying  One To Zero or More        CourseId  NO 
StudentEnrollmentPeriod  Non-Identifying  One To Zero or More        StudentEnrollmentPeriodId  NO 
Term  Non-Identifying  One To Zero or More        TermId  NO 
AutomaticBillingBatchDetail  Non-Identifying  Zero or One to Zero or More        SaAutoBillBatchDetailID  NO 
BillingTransactionCode  Non-Identifying  One To Zero or More        BillingTransactionCodeId  NO 
StudentAccountPendingTransaction  Non-Identifying  Zero or One to Zero or More        StudentAccountPendingTransactionId  NO 
Campus  Non-Identifying  One To Zero or More        CampusId  NO 
Staff  Non-Identifying  One To Zero or More        LastModifiedUserId  NO 
StudentAccountPendingTransaction  Non-Identifying  Zero or One to Zero or More        StudentAccountPendingTransactionId  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

StudentAccountPendingTransactionCourse Check Constraints 
Check Constraint Name  CheckConstraint